CREATE VIEW [dbo].[vOfferedCustomerExperience]
AS
SELECT [dbo].[OfferedCustomerExperience].[OfferedCustomerExperienceKey],
       [dbo].[Offering].[OfferingKey],
       [dbo].[OfferedCustomerExperience].[OfferedCustomerExperienceGrade],
       [dbo].[OfferedCustomerExperience].[OfferedCustomerExperienceGradeKey],
       [dbo].[OfferedCustomerExperience].[OfferedCustomerExperienceDate],
       [dbo].[ExperienceDefinition].[ExperienceDefinitionKey],
       [dbo].[ExperienceDefinition].[ExperienceDefinitionName],
       [dbo].[ExperienceDefinition].[ExperienceDefinitionCode],
       [dbo].[ExperienceDefinition].[ExperienceDefinitionDesc],
       [dbo].[ExperienceDefinition].[NumberOfUnits],
       [dbo].[ExperienceDefinition].[RequiresGradeFlag],
       [dbo].[ExperienceDefinition].[RequiresApprovalFlag],
       [dbo].[ExperienceDefinition].[ExperienceDefinitionLocation],
       [dbo].[ExperienceDefinition].[ExperienceDefinitionDate],
       [dbo].[ExperienceDefinition].[ExperienceDefinitionStatusCode],
       [dbo].[Program].[ProgramKey],
       [dbo].[Program].[ProgramName],
       [dbo].[Program].[UserDefinedExperiencesFlag],
       [dbo].[Program].[UomKey],
       [dbo].[Program].[MinimumValue],
       [dbo].[Program].[MaximumValue],
       [dbo].[Program].[ProgramDescr],
       [dbo].[Program].[ProgramStatusCode],
       [dbo].[Offering].[OfferingName],
       [dbo].[Offering].[OfferingCode],
       [dbo].[Offering].[OfferingDesc],
       [dbo].[Offering].[ContactKey],
       [dbo].[Offering].[LocationKey],
       [dbo].[Offering].[OfferingDate],
       [dbo].[Offering].[AllowChangesFlag],
       ISNULL(ISNULL([dbo].[Location].[LocationName], [dbo].[ExperienceDefinition].[ExperienceDefinitionLocation]), '') AS LocationName,
       [dbo].[vBoNetContact].[Company]
FROM [dbo].[OfferedCustomerExperience]
      INNER JOIN [dbo].[Offering] ON [dbo].[OfferedCustomerExperience].[OfferingKey] = [dbo].[Offering].[OfferingKey]
      INNER JOIN [dbo].[ExperienceDefinition] ON [dbo].[Offering].[ExperienceDefinitionKey] = [dbo].[ExperienceDefinition].[ExperienceDefinitionKey]
      INNER JOIN [dbo].[Program] ON [dbo].[ExperienceDefinition].[ProgramKey] = [dbo].[Program].[ProgramKey]
      LEFT OUTER JOIN [dbo].[Location] ON [dbo].[Offering].[LocationKey] = [dbo].[Location].[LocationKey]
      LEFT OUTER JOIN [dbo].[vBoNetContact] ON [dbo].[Offering].[ContactKey] = [dbo].[vBoNetContact].[ContactKey]

GO